UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'tnl3H5yWarBrNLX3uklmR0VpX049TA6CV1WGhQTaSC4='
WHERE
key_id = '4903e391cfabf64cc191304cb5279f78c70165363990f90461792b9d824f636c'
AND (
token = 'tnl3H5yWarBrNLX3uklmR0VpX049TA6CV1WGhQTaSC4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)