UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '16lLbK2ttw79Xj/5ZD4l3S7oWFxNJXsxliZtnbTut4s='
WHERE
key_id = 'c9e2125c40f0bea5cd902c986aebbe2e093645d5ada4f52e1029485b3a476aea'
AND (
token = '16lLbK2ttw79Xj/5ZD4l3S7oWFxNJXsxliZtnbTut4s='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)