UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hlYpZkL045I3e9hSyLzlsJkQYRQWyl2owMDP/PyIYJg='
WHERE
key_id = 'cab0147453206776733ee341b50216f4d07e2dd69f669c5e8db3e864fc8a48f2'
AND (
token = 'hlYpZkL045I3e9hSyLzlsJkQYRQWyl2owMDP/PyIYJg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)