UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'bf0ZwltGhRuzA9D3uqYbYt7F2We4AhcGUYxU35Mpti8='
WHERE
key_id = '9d750e397650bf235352fe04fcf2108c7fd2269bd5935c5cd04a42ebbe7fe167'
AND (
token = 'bf0ZwltGhRuzA9D3uqYbYt7F2We4AhcGUYxU35Mpti8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)