UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pf9latLNv+mqYkWEDOVD8NLf4Lr9Ap+Uq9z8FH+iZas='
WHERE
key_id = '9237a02ff30f00734f230efa3386d1e9e9267e542fc0b7afe5c3b429fe5b903e'
AND (
token = 'pf9latLNv+mqYkWEDOVD8NLf4Lr9Ap+Uq9z8FH+iZas='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)