UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xB208A9HjCenNZENEHUWY9G7hw1t/wXVVnTijx2VyUk='
WHERE
key_id = 'f1ec0ef21680987b6b1737ba319387bbc6eccee5ec9572b5a8ebd28d72b06371'
AND (
token = 'xB208A9HjCenNZENEHUWY9G7hw1t/wXVVnTijx2VyUk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)