UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6MGze6rDLNE8tCbcO9eIIVS1+itMdV6EjtoOqDIx7vg='
WHERE
key_id = '2e2381b3f5b34810731ca06fdb729a7718816d702aa830981f156dff5ab945bc'
AND (
token = '6MGze6rDLNE8tCbcO9eIIVS1+itMdV6EjtoOqDIx7vg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)