UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'B9coDKScOWBcBJVCB9ws1jMH+ycRiCKm6n0IaSx5FI8='
WHERE
key_id = 'c21da9a88a383f1c14f2bac8b0abab435f77208ced73dcc6377774f95a4b5b2e'
AND (
token = 'B9coDKScOWBcBJVCB9ws1jMH+ycRiCKm6n0IaSx5FI8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)