UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'oQJXO/eV62tGjQbYzhO3st789Ks0mQril1UPIQHyag4='
WHERE
key_id = '0dae79031dbd7f81f8b31448e7c18bbb8ad57d0a3c2e54299996203ae4ab3ea9'
AND (
token = 'oQJXO/eV62tGjQbYzhO3st789Ks0mQril1UPIQHyag4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)