UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8PxNTYYuQ84v3PUtad9/+YN9vs1K2jd+l2O8Qd/NGjA='
WHERE
key_id = '86c2d0085caab661f07d42bda8d6b3bd64c6765919a9bde1d413f522f9c596fd'
AND (
token = '8PxNTYYuQ84v3PUtad9/+YN9vs1K2jd+l2O8Qd/NGjA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)