UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'i7tpHIXjGCZ/tWOd8zzzltC9AsZiJJPNUzmBMIBP0Fg='
WHERE
key_id = '1916e7ceece69950b19dfa47654c8ee82eafeafe00364bcb41e3f2d13f31a682'
AND (
token = 'i7tpHIXjGCZ/tWOd8zzzltC9AsZiJJPNUzmBMIBP0Fg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)