UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gX200lroGFh9nvkl4PT73XQyZpelX7BqgGvSsAwS7JU='
WHERE
key_id = 'c6489aad4f65a9e2ed5ce71a3573e3c3154ffb2d1b23796dd8227c1373a2dac4'
AND (
token = 'gX200lroGFh9nvkl4PT73XQyZpelX7BqgGvSsAwS7JU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)