UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0Dv2M2CR65J5wiaE6RT3vHPeCGHVLncXxRJ2optslIk='
WHERE
key_id = 'ab55ce625699401d20af1c7e9e184b72664efd6c79710c039048963b1ba69a28'
AND (
token = '0Dv2M2CR65J5wiaE6RT3vHPeCGHVLncXxRJ2optslIk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)