UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4MIDWf5bzjCND4WWXJrTRp89Wh258jH0QpkiXPTeU5s='
WHERE
key_id = '5d80eaf34938b9321f4f7ee08f454d9d6f351b18616d3ae56f1a54eab6656b8f'
AND (
token = '4MIDWf5bzjCND4WWXJrTRp89Wh258jH0QpkiXPTeU5s='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)