UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8uzt69t8W01fub1tned3togXClEDp45vI47Lhcjkrxk='
WHERE
key_id = '2969a60274badf8aa1a85f3ae60534df35f28564bb5127a1a1f53b3cb6909aee'
AND (
token = '8uzt69t8W01fub1tned3togXClEDp45vI47Lhcjkrxk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)