UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'aUEtPeK77QzrAWYu/F1Nh3h8SxAYexNvJRuVIGgS91U='
WHERE
key_id = '8156f6645751dc1550ebbbe57e725b7a4482fff0c1d9faf16f0c9f02de70dfa4'
AND (
token = 'aUEtPeK77QzrAWYu/F1Nh3h8SxAYexNvJRuVIGgS91U='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)