UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'cAxrmNdCOMnhVdw8VaVyt97jdjZotnDMDKR6A0q7u8I='
WHERE
key_id = '3855a507e9dca2e64c3b470f0608c26e0cb1a2ec596f4a33d4361a505e2c1a28'
AND (
token = 'cAxrmNdCOMnhVdw8VaVyt97jdjZotnDMDKR6A0q7u8I='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)