UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'tD+9TrCwZYcEcyUUyCfGZXLNS9eO7RjmdE8NnQYvn3U='
WHERE
key_id = 'd6d78da7aadfd1977e22f073a9669e833510ee3a1a619fb52f16158b3c5c1a67'
AND (
token = 'tD+9TrCwZYcEcyUUyCfGZXLNS9eO7RjmdE8NnQYvn3U='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)