UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6Ye+5XwvdJLWBeAgUyal6LzVUXO4pz5/gxwvcWb/IWw='
WHERE
key_id = '8dcc04a00eb4cffeb76625ef48ec1d845e8256418ee04b0d73327030267ca036'
AND (
token = '6Ye+5XwvdJLWBeAgUyal6LzVUXO4pz5/gxwvcWb/IWw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)