UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'kLBmJRqyu7EM0OqS35kKG2hR4lHmdYEUkr618mqJgGE='
WHERE
key_id = 'bf811e21cdc1a035ca38ebd368fefb1193e616b769f988a00e984f3117e0a8be'
AND (
token = 'kLBmJRqyu7EM0OqS35kKG2hR4lHmdYEUkr618mqJgGE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)