UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'AgZmhlZHmDiqgzvDIptf/GCyJgRJCXDzPb949MSYMtU='
WHERE
key_id = '8457a9a0aea88345e041e15aa2935efbbff69b7e2e2b130eedf6997c5fc4cb44'
AND (
token = 'AgZmhlZHmDiqgzvDIptf/GCyJgRJCXDzPb949MSYMtU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)