UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'p1mC0KSz9WGpNb/+OpvPsPkhwpUIVXa1A+l2kf8zJDM='
WHERE
key_id = 'be4a0f4ea4d9192fc6260629117bc302d82800099fbe75de66a19cf67b41addd'
AND (
token = 'p1mC0KSz9WGpNb/+OpvPsPkhwpUIVXa1A+l2kf8zJDM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)