UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7DFBxkGcZQJZiluP9TukryvvqM8qd9qSS8jjdEEstjw='
WHERE
key_id = 'a55faeccc2d792130e1c4adffc91e67bdc56be71c719024e5e2c94932c200d0b'
AND (
token = '7DFBxkGcZQJZiluP9TukryvvqM8qd9qSS8jjdEEstjw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)