UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Z909J+4eKjW1d7fcGoVzNsxisCx1Ogb1EjPUF9/XGM4='
WHERE
key_id = 'b69754dab5587d842adbfcb108a4987d9da03b63670d72aa9f9f3573eb8bfa2c'
AND (
token = 'Z909J+4eKjW1d7fcGoVzNsxisCx1Ogb1EjPUF9/XGM4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)