UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'P4cmruG8G5fiigSSzlXHIwIuzuc4otC7oF8GhTVM+CA='
WHERE
key_id = 'e963d573f9d9ef43fe5872c445a706213846ef254d05fd7479919b32883521e1'
AND (
token = 'P4cmruG8G5fiigSSzlXHIwIuzuc4otC7oF8GhTVM+CA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)