UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'bc9L3yP4RdBAr6K9TZ06RS2jZeydMjEF+RCx7he3us8='
WHERE
key_id = '681c23c0de4ad7409d685bdd79c0e1983d9e82e6904014b9df617e5c4285d3e5'
AND (
token = 'bc9L3yP4RdBAr6K9TZ06RS2jZeydMjEF+RCx7he3us8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)