UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '+h/sBoBA5ftsrM8OtdT6ER0x09BMMzducW8D6Bgxwik='
WHERE
key_id = 'dec707fbec05c2eff3b45e0f6153a2a8ff6d07eed765d0cd21ae4cc9327eaa18'
AND (
token = '+h/sBoBA5ftsrM8OtdT6ER0x09BMMzducW8D6Bgxwik='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)