UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4uYhcVbPX39WZMigqhj1nbjjGzUX5XTKnuZE+zBHNgw='
WHERE
key_id = '9a84c658e3148abd9d4e83b46e0af994118a794dca34e556a2211236e07b7712'
AND (
token = '4uYhcVbPX39WZMigqhj1nbjjGzUX5XTKnuZE+zBHNgw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)