UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4o0HSxxeBUy5a6tlYitS4Gsc3xvMhIbqaiMERzglfuI='
WHERE
key_id = '52b4a9828fafd6a9a3360468a16fd3f539bd08f3bfd0972160d1b8dfc4c5e8fe'
AND (
token = '4o0HSxxeBUy5a6tlYitS4Gsc3xvMhIbqaiMERzglfuI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)