UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'rE4KzGSgNacPaVpEgaDb7SVH1xc+BWoygI5YECGDqcA='
WHERE
key_id = 'a18e3e2a39e4cd56fe872d4f80de44a28f417f8a06cc73ad8d4367e3e4a5d90b'
AND (
token = 'rE4KzGSgNacPaVpEgaDb7SVH1xc+BWoygI5YECGDqcA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)