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