UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'cLzaWENJDZcmiuCKosfmrPgFysqH9QgH3akt7ao73w8='
WHERE
key_id = 'ba2bbdc8bbb56503789bbd625c33c52c7b2c1d050bd7d4117021c0facda44cbe'
AND (
token = 'cLzaWENJDZcmiuCKosfmrPgFysqH9QgH3akt7ao73w8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)