UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'aJ5YyxBZNtJVBdTcNAkV7oKMhTvldALiBoxsxPZWsmc='
WHERE
key_id = '3117b0ee426d7fc95d8f1f04ea361578bb898e5651dd8f1d6728fca8078fd3ac'
AND (
token = 'aJ5YyxBZNtJVBdTcNAkV7oKMhTvldALiBoxsxPZWsmc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)