UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '38bOE6MqejZMEuNej5o0QCdu4Pnx26m4VcMomtndtLc='
WHERE
key_id = '267b1e8e19518e50300bc6b402d9979285412dcc73d67df5388ecf42d18e99d1'
AND (
token = '38bOE6MqejZMEuNej5o0QCdu4Pnx26m4VcMomtndtLc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)