UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZjwFOCxOHfGKjAdSkiFQy+L6IgGnYRX0pkDd6YA+d4E='
WHERE
key_id = 'd946a2ca004c9a10c834b2ee9af3b595647638f210ea8a1bb8a2beeec4be4188'
AND (
token = 'ZjwFOCxOHfGKjAdSkiFQy+L6IgGnYRX0pkDd6YA+d4E='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)