UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zVGfc5acMhx7iOuGQjxfWh8zEB9L9ynyj8ZGfwoZYlk='
WHERE
key_id = '3f2e0ee8caf0c3048499e0e60d43ebd2d12d080b724b4b77688f9f99409c0ef8'
AND (
token = 'zVGfc5acMhx7iOuGQjxfWh8zEB9L9ynyj8ZGfwoZYlk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)