UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'CGJl4S5tFwugkoMt49qeTIOcuWu7+cavG8sKT9TBoAY='
WHERE
key_id = '12c5b316faf1110637409161bfd13d2142fdbb4482a068a2de9cbfec89f3ea9e'
AND (
token = 'CGJl4S5tFwugkoMt49qeTIOcuWu7+cavG8sKT9TBoAY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)