UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pjmU9+OKf5ShDrhhmRfMKgn463ntDivbKaxa8pzeJok='
WHERE
key_id = 'f4c9af562f60f4e16b42cbad6e6d4b1dfcaf114578a79ab6669d09ab2b30beaf'
AND (
token = 'pjmU9+OKf5ShDrhhmRfMKgn463ntDivbKaxa8pzeJok='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)